SHOW DATA SKEW

SHOW-DATA-SKEW

Name

SHOW DATA SKEW

Description

This statement is used to view the data skew of a table or a partition.

Syntax:

SHOW DATA SKEW FROM [db_name.]tbl_name [PARTITION (p1)];

Note:

1. You have to specify (only) one partition. For non-partitioned tables, the partition name is the same as the table name.
2. The result will show the number of rows, data volume, and data proportion of each bucket under the specified partition

Example

1. View the data skew of the table

   SHOW DATA SKEW FROM db1.test PARTITION(p1);

Keywords

SHOW, DATA, SKEW

Best Practice